index
Joseph Koroki
3/4/2022
source("analysis.R")## Warning: package 'gt' was built under R version 4.1.2## -- Attaching packages --------------------------------------- tidyverse 1.3.1 --## v ggplot2 3.3.5 v purrr 0.3.4
## v tibble 3.1.6 v dplyr 1.0.8
## v tidyr 1.1.4 v stringr 1.4.0
## v readr 2.0.2 v forcats 0.5.1## Warning: package 'tibble' was built under R version 4.1.2## Warning: package 'dplyr' was built under R version 4.1.2## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()## Warning: package 'zoo' was built under R version 4.1.2##
## Attaching package: 'zoo'## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric## Warning: package 'gtsummary' was built under R version 4.1.2## Warning: package 'leaflet' was built under R version 4.1.2## Warning: package 'plotly' was built under R version 4.1.2##
## Attaching package: 'plotly'## The following object is masked from 'package:ggplot2':
##
## last_plot## The following object is masked from 'package:stats':
##
## filter## The following object is masked from 'package:graphics':
##
## layout## Warning: package 'maps' was built under R version 4.1.2##
## Attaching package: 'maps'## The following object is masked from 'package:purrr':
##
## mapsummary(df_for_chart2)## yfips year fips state
## Min. :201001001 Min. :2010 Min. : 1001 Length:3139
## 1st Qu.:201018174 1st Qu.:2010 1st Qu.:18174 Class :character
## Median :201029171 Median :2010 Median :29171 Mode :character
## Mean :201030367 Mean :2010 Mean :30367
## 3rd Qu.:201045082 3rd Qu.:2010 3rd Qu.:45082
## Max. :201056045 Max. :2010 Max. :56045
##
## county_name total_pop total_pop_15to64 female_pop_15to64
## Length:3139 Min. : 0 Min. : 0 Min. : 0
## Class :character 1st Qu.: 11061 1st Qu.: 7042 1st Qu.: 3411
## Mode :character Median : 25798 Median : 16677 Median : 8219
## Mean : 98543 Mean : 66151 Mean : 33231
## 3rd Qu.: 66490 3rd Qu.: 44048 3rd Qu.: 22026
## Max. :9822433 Max. :6799811 Max. :3412504
##
## male_pop_15to64 aapi_pop_15to64 black_pop_15to64 latinx_pop_15to64
## Min. : 0 Min. : 0.0 Min. : 0 Min. : 0
## 1st Qu.: 3630 1st Qu.: 26.0 1st Qu.: 70 1st Qu.: 163
## Median : 8509 Median : 94.0 Median : 563 Median : 566
## Mean : 32919 Mean : 3695.6 Mean : 8555 Mean : 10656
## 3rd Qu.: 22116 3rd Qu.: 521.5 3rd Qu.: 3775 3rd Qu.: 2660
## Max. :3387307 Max. :1020232.0 Max. :1343491 Max. :3194413
##
## native_pop_15to64 white_pop_15to64 urbanicity region
## Min. : 0.0 Min. : 0 Length:3139 Length:3139
## 1st Qu.: 27.0 1st Qu.: 5346 Class :character Class :character
## Median : 79.0 Median : 13216 Mode :character Mode :character
## Mean : 555.7 Mean : 42688
## 3rd Qu.: 325.0 3rd Qu.: 35486
## Max. :45153.0 Max. :1968203
##
## division commuting_zone metro_area land_area
## Length:3139 Min. : 1.0 Min. :10100 Min. : 2.05
## Class :character 1st Qu.:108.0 1st Qu.:19100 1st Qu.: 431.17
## Mode :character Median :253.0 Median :29700 Median : 616.81
## Mean :277.5 Mean :29630 Mean : 1125.57
## 3rd Qu.:426.0 3rd Qu.:39560 3rd Qu.: 924.06
## Max. :903.0 Max. :49820 Max. :145572.46
## NA's :7 NA's :1336 NA's :1
## total_jail_pop female_jail_pop male_jail_pop female_adult_jail_pop
## Min. : 0.00 Min. : 0.000 Min. : 0.0 Min. : 0.00
## 1st Qu.: 27.00 1st Qu.: 2.053 1st Qu.: 22.0 1st Qu.: 2.01
## Median : 77.62 Median : 9.000 Median : 64.0 Median : 9.00
## Mean : 256.73 Mean : 31.535 Mean : 221.9 Mean : 31.38
## 3rd Qu.: 205.06 3rd Qu.: 26.000 3rd Qu.: 174.2 3rd Qu.: 26.00
## Max. :18190.39 Max. :2382.740 Max. :15006.3 Max. :2382.74
## NA's :184 NA's :207 NA's :207 NA's :208
## female_juvenile_jail_pop male_adult_jail_pop male_juvenile_jail_pop
## Min. : 0.0000 Min. : 0.00 Min. : 0.000
## 1st Qu.: 0.0000 1st Qu.: 22.00 1st Qu.: 0.000
## Median : 0.0000 Median : 63.89 Median : 0.000
## Mean : 0.1668 Mean : 219.94 Mean : 1.976
## 3rd Qu.: 0.0000 3rd Qu.: 173.12 3rd Qu.: 0.000
## Max. :19.0000 Max. :15005.45 Max. :381.000
## NA's :208 NA's :207 NA's :208
## aapi_jail_pop black_jail_pop latinx_jail_pop native_jail_pop
## Min. : 0.000 Min. : 0.00 Min. : 0.00 Min. : 0.000
## 1st Qu.: 0.000 1st Qu.: 1.62 1st Qu.: 1.00 1st Qu.: 0.000
## Median : 0.000 Median : 9.75 Median : 3.12 Median : 0.000
## Mean : 2.569 Mean : 96.33 Mean : 42.29 Mean : 3.494
## 3rd Qu.: 1.080 3rd Qu.: 52.62 3rd Qu.: 13.51 3rd Qu.: 1.535
## Max. :341.480 Max. :7162.97 Max. :8101.37 Max. :383.000
## NA's :192 NA's :192 NA's :192 NA's :192
## white_jail_pop other_race_jail_pop total_jail_pretrial
## Min. : 0.00 Min. : 0.000 Min. : 0.00
## 1st Qu.: 15.25 1st Qu.: 0.000 1st Qu.: 13.88
## Median : 45.88 Median : 0.000 Median : 39.82
## Mean : 112.31 Mean : 3.835 Mean : 148.83
## 3rd Qu.: 118.81 3rd Qu.: 0.000 3rd Qu.: 108.00
## Max. :5034.00 Max. :1637.000 Max. :11394.90
## NA's :192 NA's :202 NA's :198
## total_jail_from_prison total_jail_from_other_jail total_jail_from_fed
## Min. : 0.00 Min. : 0.00 Min. : 0.00
## 1st Qu.: 0.00 1st Qu.: 0.00 1st Qu.: 0.00
## Median : 2.63 Median : 0.75 Median : 0.16
## Mean : 32.09 Mean : 10.10 Mean : 17.35
## 3rd Qu.: 17.91 3rd Qu.: 6.00 3rd Qu.: 4.38
## Max. :3394.00 Max. :1156.25 Max. :1178.44
## NA's :201 NA's :201 NA's :186
## total_jail_from_bia total_jail_from_bop total_jail_from_ice
## Min. : 0.0000 Min. : 0.0000 Min. : 0.00
## 1st Qu.: 0.0000 1st Qu.: 0.0000 1st Qu.: 0.00
## Median : 0.0000 Median : 0.0000 Median : 0.00
## Mean : 0.1039 Mean : 0.7647 Mean : 7.12
## 3rd Qu.: 0.0000 3rd Qu.: 0.0000 3rd Qu.: 0.62
## Max. :27.0000 Max. :624.0000 Max. :1175.75
## NA's :192 NA's :198 NA's :192
## total_jail_from_marshals total_jail_from_other_fed jail_rated_capacity
## Min. : 0.000 Min. : 0.0000 Min. : 0.00
## 1st Qu.: 0.000 1st Qu.: 0.0000 1st Qu.: 34.88
## Median : 0.000 Median : 0.0000 Median : 96.00
## Mean : 8.566 Mean : 0.8323 Mean : 293.57
## 3rd Qu.: 0.995 3rd Qu.: 0.0000 3rd Qu.: 234.41
## Max. :1110.000 Max. :315.0000 Max. :19404.00
## NA's :192 NA's :192 NA's :183
## private_jail_flag regional_jail_flag total_jail_adm total_jail_dis
## Min. :0.00000 Min. :0.0000 Min. : 0 Min. : 0
## 1st Qu.:0.00000 1st Qu.:0.0000 1st Qu.: 520 1st Qu.: 468
## Median :0.00000 Median :0.0000 Median : 1387 Median : 1273
## Mean :0.01175 Mean :0.1456 Mean : 4200 Mean : 4171
## 3rd Qu.:0.00000 3rd Qu.:0.0000 3rd Qu.: 3640 3rd Qu.: 3511
## Max. :1.00000 Max. :1.0000 Max. :177103 Max. :179013
## NA's :74 NA's :329 NA's :383
## total_jail_pop_dcrp female_jail_pop_dcrp male_jail_pop_dcrp
## Min. : 0.0 Min. : 0.00 Min. : 0.0
## 1st Qu.: 28.0 1st Qu.: 3.00 1st Qu.: 24.8
## Median : 78.0 Median : 10.00 Median : 68.0
## Mean : 232.8 Mean : 29.68 Mean : 204.0
## 3rd Qu.: 204.0 3rd Qu.: 28.00 3rd Qu.: 175.0
## Max. :13049.0 Max. :916.00 Max. :12133.0
## NA's :275 NA's :316 NA's :275
## total_jail_adm_dcrp female_jail_adm_dcrp male_jail_adm_dcrp total_prison_pop
## Min. : 0 Min. : 0.0 Min. : 0.0 Min. : 0.0
## 1st Qu.: 572 1st Qu.: 88.0 1st Qu.: 466.8 1st Qu.: 46.0
## Median : 1363 Median : 250.0 Median : 1098.5 Median : 120.0
## Mean : 3699 Mean : 720.2 Mean : 2986.9 Mean : 476.3
## 3rd Qu.: 3511 3rd Qu.: 699.0 3rd Qu.: 2798.5 3rd Qu.: 306.0
## Max. :131401 Max. :33004.0 Max. :98397.0 Max. :54719.0
## NA's :278 NA's :295 NA's :279 NA's :500
## female_prison_pop male_prison_pop aapi_prison_pop black_prison_pop
## Min. : 0.00 Min. : 0.0 Min. : 0.000 Min. : 0.0
## 1st Qu.: 6.00 1st Qu.: 69.0 1st Qu.: 0.000 1st Qu.: 10.5
## Median : 14.00 Median : 152.0 Median : 0.000 Median : 47.0
## Mean : 43.43 Mean : 573.5 Mean : 9.356 Mean : 314.4
## 3rd Qu.: 35.00 3rd Qu.: 372.0 3rd Qu.: 0.000 3rd Qu.: 175.5
## Max. :3324.00 Max. :51395.0 Max. :1461.000 Max. :21080.0
## NA's :1235 NA's :1235 NA's :2476 NA's :1584
## latinx_prison_pop native_prison_pop other_race_prison_pop white_prison_pop
## Min. : 0.0 Min. : 0.0 Min. : 0.00 Min. : 0.0
## 1st Qu.: 4.0 1st Qu.: 0.0 1st Qu.: 0.00 1st Qu.: 47.0
## Median : 14.0 Median : 0.0 Median : 0.00 Median : 103.0
## Mean : 158.9 Mean : 14.5 Mean : 15.03 Mean : 233.1
## 3rd Qu.: 52.0 3rd Qu.: 11.0 3rd Qu.: 6.00 3rd Qu.: 232.0
## Max. :24250.0 Max. :1066.0 Max. :2189.00 Max. :9187.0
## NA's :1845 NA's :2332 NA's :2401 NA's :1216
## aapi_female_prison_pop aapi_male_prison_pop black_female_prison_pop
## Min. : 0.0000 Min. : 0.000 Min. : 0.0
## 1st Qu.: 0.0000 1st Qu.: 0.000 1st Qu.: 0.0
## Median : 0.0000 Median : 0.000 Median : 3.0
## Mean : 0.5544 Mean : 6.276 Mean : 16.2
## 3rd Qu.: 0.0000 3rd Qu.: 0.000 3rd Qu.: 9.0
## Max. :50.0000 Max. :260.000 Max. :1367.0
## NA's :2542 NA's :2542 NA's :1697
## black_male_prison_pop latinx_female_prison_pop latinx_male_prison_pop
## Min. : 0.0 Min. : 0.000 Min. : 0.0
## 1st Qu.: 12.0 1st Qu.: 0.000 1st Qu.: 5.0
## Median : 48.0 Median : 0.000 Median : 15.0
## Mean : 303.3 Mean : 7.948 Mean : 156.9
## 3rd Qu.: 176.0 3rd Qu.: 3.000 3rd Qu.: 52.0
## Max. :19713.0 Max. :1173.000 Max. :23077.0
## NA's :1697 NA's :1930 NA's :1930
## native_female_prison_pop native_male_prison_pop other_race_female_prison_pop
## Min. : 0.000 Min. : 0.00 Min. : 0.0000
## 1st Qu.: 0.000 1st Qu.: 0.00 1st Qu.: 0.0000
## Median : 0.000 Median : 0.00 Median : 0.0000
## Mean : 1.831 Mean : 12.88 Mean : 0.8782
## 3rd Qu.: 1.000 3rd Qu.: 10.00 3rd Qu.: 0.0000
## Max. :149.000 Max. :917.00 Max. :103.0000
## NA's :2413 NA's :2413 NA's :2474
## other_race_male_prison_pop white_female_prison_pop white_male_prison_pop
## Min. : 0.00 Min. : 0.00 Min. : 0.0
## 1st Qu.: 0.00 1st Qu.: 5.00 1st Qu.: 46.0
## Median : 0.00 Median : 11.00 Median : 101.0
## Mean : 15.46 Mean : 24.49 Mean : 219.7
## 3rd Qu.: 6.00 3rd Qu.: 27.00 3rd Qu.: 218.5
## Max. :2086.00 Max. :1133.00 Max. :8054.0
## NA's :2474 NA's :1376 NA's :1376
## total_prison_adm female_prison_adm male_prison_adm aapi_prison_adm
## Min. : 0.0 Min. : 0.00 Min. : 0.0 Min. : 0.000
## 1st Qu.: 24.0 1st Qu.: 6.00 1st Qu.: 38.0 1st Qu.: 0.000
## Median : 62.0 Median : 12.00 Median : 82.0 Median : 0.000
## Mean : 233.5 Mean : 36.65 Mean : 279.3 Mean : 3.856
## 3rd Qu.: 157.0 3rd Qu.: 30.00 3rd Qu.: 196.0 3rd Qu.: 0.000
## Max. :26594.0 Max. :3031.00 Max. :23563.0 Max. :838.000
## NA's :381 NA's :1223 NA's :1223 NA's :2381
## black_prison_adm latinx_prison_adm native_prison_adm other_race_prison_adm
## Min. : 0 Min. : 0.00 Min. : 0.00 Min. : 0.00
## 1st Qu.: 7 1st Qu.: 0.00 1st Qu.: 0.00 1st Qu.: 0.00
## Median : 26 Median : 7.00 Median : 0.00 Median : 0.00
## Mean : 147 Mean : 86.36 Mean : 11.48 Mean : 7.14
## 3rd Qu.: 87 3rd Qu.: 26.50 3rd Qu.: 6.00 3rd Qu.: 4.00
## Max. :12175 Max. :11825.00 Max. :1243.00 Max. :723.00
## NA's :1606 NA's :1908 NA's :2264 NA's :2302
## white_prison_adm aapi_female_prison_adm aapi_male_prison_adm
## Min. : 0.0 Min. : 0.000 Min. : 0.000
## 1st Qu.: 26.0 1st Qu.: 0.000 1st Qu.: 0.000
## Median : 59.0 Median : 0.000 Median : 0.000
## Mean : 129.7 Mean : 0.411 Mean : 2.529
## 3rd Qu.: 132.0 3rd Qu.: 0.000 3rd Qu.: 0.000
## Max. :4481.0 Max. :38.000 Max. :98.000
## NA's :1187 NA's :2555 NA's :2555
## black_female_prison_adm black_male_prison_adm latinx_female_prison_adm
## Min. : 0.00 Min. : 0.0 Min. : 0.000
## 1st Qu.: 0.00 1st Qu.: 7.0 1st Qu.: 0.000
## Median : 2.00 Median : 24.0 Median : 0.000
## Mean : 12.49 Mean : 137.6 Mean : 7.827
## 3rd Qu.: 7.00 3rd Qu.: 82.5 3rd Qu.: 3.000
## Max. :1082.00 Max. :8281.0 Max. :1120.000
## NA's :1856 NA's :1856 NA's :2090
## latinx_male_prison_adm native_female_prison_adm native_male_prison_adm
## Min. : 0.0 Min. : 0.000 Min. : 0.000
## 1st Qu.: 0.0 1st Qu.: 0.000 1st Qu.: 0.000
## Median : 8.0 Median : 0.000 Median : 0.000
## Mean : 89.8 Mean : 1.273 Mean : 6.531
## 3rd Qu.: 31.0 3rd Qu.: 1.000 3rd Qu.: 6.000
## Max. :10705.0 Max. :90.000 Max. :413.000
## NA's :2090 NA's :2454 NA's :2454
## other_race_female_prison_adm other_race_male_prison_adm
## Min. : 0.0000 Min. : 0.000
## 1st Qu.: 0.0000 1st Qu.: 0.000
## Median : 0.0000 Median : 0.000
## Mean : 0.7202 Mean : 7.193
## 3rd Qu.: 0.0000 3rd Qu.: 3.000
## Max. :32.0000 Max. :691.000
## NA's :2485 NA's :2485
## white_female_prison_adm white_male_prison_adm total_jail_pop_rate
## Min. : 0.00 Min. : 0.0 Min. : 0.0
## 1st Qu.: 4.00 1st Qu.: 25.0 1st Qu.: 232.7
## Median : 9.00 Median : 56.0 Median : 370.7
## Mean : 21.60 Mean : 115.6 Mean : 536.9
## 3rd Qu.: 22.25 3rd Qu.: 117.0 3rd Qu.: 552.5
## Max. :744.00 Max. :3737.0 Max. :29109.5
## NA's :1499 NA's :1499 NA's :184
## female_jail_pop_rate male_jail_pop_rate aapi_jail_pop_rate black_jail_pop_rate
## Min. : 0.00 Min. : 0.0 Min. : 0.0 Min. : 0.0
## 1st Qu.: 43.59 1st Qu.: 368.1 1st Qu.: 0.0 1st Qu.: 676.6
## Median : 85.99 Median : 588.3 Median : 0.0 Median : 1316.0
## Mean : 124.63 Mean : 910.3 Mean : 769.7 Mean : 3431.4
## 3rd Qu.: 149.12 3rd Qu.: 931.9 3rd Qu.: 154.6 3rd Qu.: 2754.3
## Max. :6781.23 Max. :62668.1 Max. :166666.7 Max. :268000.0
## NA's :207 NA's :207 NA's :207 NA's :204
## latinx_jail_pop_rate native_jail_pop_rate white_jail_pop_rate
## Min. : 0.0 Min. : 0.0 Min. : 0.0
## 1st Qu.: 201.4 1st Qu.: 0.0 1st Qu.: 165.0
## Median : 432.9 Median : 0.0 Median : 267.4
## Mean : 1198.9 Mean : 1632.9 Mean : 402.7
## 3rd Qu.: 893.8 3rd Qu.: 703.6 3rd Qu.: 428.6
## Max. :116666.7 Max. :277000.0 Max. :52292.2
## NA's :192 NA's :201 NA's :192
## total_jail_adm_rate total_jail_pretrial_rate total_prison_pop_rate
## Min. : 0 Min. : 0.0 Min. : 0.0
## 1st Qu.: 4250 1st Qu.: 120.6 1st Qu.: 367.0
## Median : 6881 Median : 205.9 Median : 586.1
## Mean : 8536 Mean : 273.7 Mean : 685.0
## 3rd Qu.: 10491 3rd Qu.: 318.2 3rd Qu.: 875.0
## Max. :193585 Max. :13402.3 Max. :29166.7
## NA's :329 NA's :198 NA's :500
## female_prison_pop_rate male_prison_pop_rate aapi_prison_pop_rate
## Min. : 0.00 Min. : 0.0 Min. : 0.00
## 1st Qu.: 52.30 1st Qu.: 739.5 1st Qu.: 0.00
## Median : 99.21 Median : 1119.2 Median : 0.00
## Mean : 127.55 Mean : 1283.7 Mean : 37.37
## 3rd Qu.: 168.53 3rd Qu.: 1611.4 3rd Qu.: 0.00
## Max. :3870.97 Max. :54140.1 Max. :1860.47
## NA's :1235 NA's :1235 NA's :2483
## black_prison_pop_rate latinx_prison_pop_rate native_prison_pop_rate
## Min. : 0 Min. : 0.0 Min. : 0.0
## 1st Qu.: 1456 1st Qu.: 232.7 1st Qu.: 0.0
## Median : 2339 Median : 522.3 Median : 0.0
## Mean : 3238 Mean : 674.4 Mean : 924.1
## 3rd Qu.: 3774 3rd Qu.: 917.9 3rd Qu.: 1262.6
## Max. :500000 Max. :6422.0 Max. :30769.2
## NA's :1593 NA's :1847 NA's :2339
## white_prison_pop_rate total_prison_adm_rate female_prison_adm_rate
## Min. : 0.0 Min. : 0.0 Min. : 0.00
## 1st Qu.: 293.6 1st Qu.: 177.5 1st Qu.: 35.10
## Median : 458.3 Median : 301.9 Median : 83.38
## Mean : 528.8 Mean : 371.0 Mean : 119.15
## 3rd Qu.: 677.0 3rd Qu.: 468.0 3rd Qu.: 153.90
## Max. :17741.9 Max. :20192.3 Max. :5806.45
## NA's :1216 NA's :382 NA's :1224
## male_prison_adm_rate aapi_prison_adm_rate black_prison_adm_rate
## Min. : 0.0 Min. : 0.00 Min. : 0.0
## 1st Qu.: 355.6 1st Qu.: 0.00 1st Qu.: 553.3
## Median : 571.5 Median : 0.00 Median : 1057.0
## Mean : 679.0 Mean : 10.82 Mean : 1659.7
## 3rd Qu.: 851.2 3rd Qu.: 0.00 3rd Qu.: 1861.0
## Max. :34394.9 Max. :929.37 Max. :350000.0
## NA's :1224 NA's :2392 NA's :1617
## latinx_prison_adm_rate native_prison_adm_rate white_prison_adm_rate
## Min. : 0.0 Min. : 0.0 Min. : 0.0
## 1st Qu.: 0.0 1st Qu.: 0.0 1st Qu.: 145.7
## Median : 193.3 Median : 0.0 Median : 249.1
## Mean : 296.7 Mean : 515.2 Mean : 314.0
## 3rd Qu.: 449.9 3rd Qu.: 415.4 3rd Qu.: 404.4
## Max. :5263.2 Max. :14634.1 Max. :12258.1
## NA's :1911 NA's :2273 NA's :1188In 2010 the maximum total incarcerated population was 9,822,433. Of that total population 1,343,491 were black individuals between the ages of 15 to 64. With an average of 8555 black individuals per facility. 1,968,203 of the incarcerated population in 2010 was white people between the ages of 15 to 64. They averaged 42,688 individuals per facility.
Including charts
Time trend chart for King County Washington and King County Texas. It is clear that the urban King County Washington has a much higher incarcerated population than a more rural King County Texas.
chart1
Variable comparison chart showing the total incarcerated population by state for 2010. California has by far the largest incarcerated population.
chart2Map chart showing the total incarcerated population densities from 1970.
mapchart1